<report xmlns="http://developer.cognos.com/schemas/report/12.0/" expressionLocale="en-us" interactivePageBreakByFrame="true" useStyleVersion="10"><!--RSU-SPC-0093 The report specification was upgraded from "http://developer.cognos.com/schemas/report/11.0/" to "http://developer.cognos.com/schemas/report/12.0/" at 2016-5-11. 21:33:24-->
				<modelPath>/content/folder[@name='Packages']/package[@name='Inventory']/model[@name='model']</modelPath>
				<drillBehavior modelBasedDrillThru="true"/>
				
				<layouts>
					<layout>
						<reportPages>
							<page name="Page1"><style><defaultStyles><defaultStyle refStyle="pg"/></defaultStyles></style>
								<pageBody><style><defaultStyles><defaultStyle refStyle="pb"/></defaultStyles></style>
									<contents>
										
									<HTMLItem>
			<dataSource>
				<staticValue>&lt;style&gt; #headerBack { display: none; } .mainHeader1 { display: none; } .mainViewerHeader3 { display: none; } &lt;/style&gt;</staticValue>
			</dataSource>
		</HTMLItem><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:1500px"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered by OnCommand Insight</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:white"/></style></textItem></contents><style><CSS value="height:24px;background-color:#6198C5;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Storage at Rest</staticValue></dataSource></textItem></contents><style><CSS value="height:36px;padding-left:10px;font-family:Arial;font-size:24px;color:#333333;background-color:#FBFBFB;border-bottom:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>At Rest Allocated Capacity</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton1" refQuery="Performance by Array">
			<contents><textItem><dataSource><dataItemValue refDataItem="Total Allocated (TB)"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,###.##' TB'"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Total Usable Capacity (with at-rest criteria)</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton4" refQuery="Performance by Array">
			<contents><textItem><dataSource><dataItemValue refDataItem="Usable Capacity (TB)"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,###.##' TB'"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>% of Usable Capacity at Rest</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton5" refQuery="Performance by Array">
			<contents><textItem><dataSource><dataItemValue refDataItem="% of Usable"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><percentFormat/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered Off VM Capacity</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton2" refQuery="VMware Powered Off">
			<contents><textItem><dataSource><dataItemValue refDataItem="Capacity (TB)"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,###.##' TB'"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>VM Capacity at Rest</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton3" refQuery="VMware at Rest">
			<contents><textItem><dataSource><dataItemValue refDataItem="Capacity (TB)"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,###.##' TB'"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="background-color:#F7F7F7;padding-bottom:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Top 10 SAN Volumes Not Accessed</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Past 90 Days)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart depth="9" maxHotspots="10000" name="Combination Chart3" refQuery="Performance by SAN Volume">
														<v2_combinationTypeTooltips/>
														<v2_commonAxis>
															<v2_ordinalAxis autoTruncation="false" manualTruncationMaxChars="12" truncationText="...">
																<v2_axisLabels>
																	<style>
																		<defaultStyles>
																			<defaultStyle refStyle="al"/>
																		</defaultStyles>
																	<CSS value="color:#454545"/></style>
																</v2_axisLabels>
															</v2_ordinalAxis>
														<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Volume Name"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="Total Allocated (GB)"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
														<v2_topLeftAxis>
															<v2_combinationChartTypes>
																<v2_bar barShape="box">
																	<v2_solidPalette>
																		<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
																	<!-- v2_solidPaletteRef ref=&amp;amp;amp;quot;gDefaultSolid&amp;amp;amp;quot;/ -->
																<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Total Allocated (GB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
															</v2_combinationChartTypes>
															<v2_axis>
																<v2_axisRange>
																	<v2_automaticRange/>
																</v2_axisRange>
																<v2_axisLabels>
																	<style>
																		<defaultStyles>
																			<defaultStyle refStyle="al"/>
																		</defaultStyles>
																	<CSS value="color:#454545"/><dataFormat><numberFormat pattern="###,###' GB'"/></dataFormat></style>
																</v2_axisLabels>
																<v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/>
															</v2_axis>
														</v2_topLeftAxis>
														<style>
															<defaultStyles>
																<defaultStyle refStyle="ch"/>
															</defaultStyles>
															<CSS value="width:500px;height:250px"/></style>
														<noDataHandler>
															<contents>
																<block>
																	<contents>
																		<textItem>
																			<dataSource>
																				<staticValue>No Data Available</staticValue>
																			</dataSource>
																			<style>
																				<CSS value="padding:10px 18px;"/>
																			</style>
																		</textItem>
																	</contents>
																</block>
															</contents>
														</noDataHandler>
														<XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Top 10 NetApp Volumes Not Accessed</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Past 90 Days)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart depth="9" maxHotspots="10000" name="Combination Chart1" refQuery="Performance by NetApp Volume">
														<v2_combinationTypeTooltips/>
														<v2_commonAxis>
															<v2_ordinalAxis autoTruncation="false" labelDisplayType="concat" manualTruncationMaxChars="10" truncationText="...">
																<v2_axisLabels>
																	<style>
																		<defaultStyles>
																			<defaultStyle refStyle="al"/>
																		</defaultStyles>
																	<CSS value="color:#454545"/></style>
																</v2_axisLabels>
															</v2_ordinalAxis>
														<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Volume Name"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="Total Allocated (GB)"/></sortList></chartNodeMember></chartNodeMembers><chartNestedNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Pool Name"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNestedNodes></chartNode></chartNodes></v2_commonAxis>
														<v2_topLeftAxis>
															<v2_combinationChartTypes>
																<v2_bar barShape="box">
																	<v2_solidPalette>
																		<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
																	<!-- v2_solidPaletteRef ref=&amp;amp;amp;quot;gDefaultSolid&amp;amp;amp;quot;/ -->
																<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Total Allocated (GB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
															</v2_combinationChartTypes>
															<v2_axis>
																<v2_axisRange>
																	<v2_automaticRange/>
																</v2_axisRange>
																<v2_axisLabels>
																	<style>
																		<defaultStyles>
																			<defaultStyle refStyle="al"/>
																		</defaultStyles>
																	<CSS value="color:#454545"/><dataFormat><numberFormat pattern="###,###' GB'"/></dataFormat></style>
																</v2_axisLabels>
																<v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/>
															</v2_axis>
														</v2_topLeftAxis>
														<style>
															<defaultStyles>
																<defaultStyle refStyle="ch"/>
															</defaultStyles>
															<CSS value="width:500px;height:250px"/></style>
														<noDataHandler>
															<contents>
																<block>
																	<contents>
																		<textItem>
																			<dataSource>
																				<staticValue>No Data Available</staticValue>
																			</dataSource>
																			<style>
																				<CSS value="padding:10px 18px;"/>
																			</style>
																		</textItem>
																	</contents>
																</block>
															</contents>
														</noDataHandler>
														<XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top;padding-left:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Top 10 VMs at Rest</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Past 90 Days)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart depth="9" maxHotspots="10000" name="Combination Chart5" refQuery="VMware at Rest">
														<v2_combinationTypeTooltips/>
														<v2_commonAxis>
															<v2_ordinalAxis>
																<v2_axisLabels>
																	<style>
																		<defaultStyles>
																			<defaultStyle refStyle="al"/>
																		</defaultStyles>
																	<CSS value="color:#454545"/></style>
																</v2_axisLabels>
															</v2_ordinalAxis>
														<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="VM Guest"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="Capacity (TB)"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
														<v2_topLeftAxis>
															<v2_combinationChartTypes>
																<v2_bar barShape="box">
																	<v2_solidPalette>
																		<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
																	<!-- v2_solidPaletteRef ref=&amp;amp;amp;quot;gDefaultSolid&amp;amp;amp;quot;/ -->
																<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Capacity (GB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
															</v2_combinationChartTypes>
															<v2_axis>
																<v2_axisRange>
																	<v2_automaticRange/>
																</v2_axisRange>
																<v2_axisLabels>
																	<style>
																		<defaultStyles>
																			<defaultStyle refStyle="al"/>
																		</defaultStyles>
																	<CSS value="color:#454545"/><dataFormat><numberFormat pattern="###,###' GB'"/></dataFormat></style>
																</v2_axisLabels>
																<v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/>
															</v2_axis>
														</v2_topLeftAxis>
														<style>
															<defaultStyles>
																<defaultStyle refStyle="ch"/>
															</defaultStyles>
															<CSS value="width:500px;height:250px"/></style>
														<noDataHandler>
															<contents>
																<block>
																	<contents>
																		<textItem>
																			<dataSource>
																				<staticValue>No Data Available</staticValue>
																			</dataSource>
																			<style>
																				<CSS value="padding:10px 18px;"/>
																			</style>
																		</textItem>
																	</contents>
																</block>
															</contents>
														</noDataHandler>
														<XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top;padding-left:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="height:10px;background-color:#F7F7F7;padding-right:10px;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Top VMs Powered Off</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(30 Days)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart depth="9" maxHotspots="10000" name="Combination Chart4" refQuery="VMware Powered Off">
														<v2_combinationTypeTooltips/>
														<v2_commonAxis>
															<v2_ordinalAxis autoTruncation="false" manualTruncationMaxChars="12" truncationText="...">
																<v2_axisLabels>
																	<style>
																		<defaultStyles>
																			<defaultStyle refStyle="al"/>
																		</defaultStyles>
																	<CSS value="color:#454545"/></style>
																</v2_axisLabels>
															</v2_ordinalAxis>
														<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="VM Guest"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="Capacity (TB)"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
														<v2_topLeftAxis>
															<v2_combinationChartTypes>
																<v2_bar barShape="box">
																	<v2_solidPalette>
																		<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
																	<!-- v2_solidPaletteRef ref=&amp;amp;amp;quot;gDefaultSolid&amp;amp;amp;quot;/ -->
																<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Capacity (GB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
															</v2_combinationChartTypes>
															<v2_axis>
																<v2_axisRange>
																	<v2_automaticRange/>
																</v2_axisRange>
																<v2_axisLabels>
																	<style>
																		<defaultStyles>
																			<defaultStyle refStyle="al"/>
																		</defaultStyles>
																	<CSS value="color:#454545"/><dataFormat><numberFormat pattern="###,###' GB'"/></dataFormat></style>
																</v2_axisLabels>
																<v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/>
															</v2_axis>
														</v2_topLeftAxis>
														<style>
															<defaultStyles>
																<defaultStyle refStyle="ch"/>
															</defaultStyles>
															<CSS value="width:500px;height:250px"/></style>
														<noDataHandler>
															<contents>
																<block>
																	<contents>
																		<textItem>
																			<dataSource>
																				<staticValue>No Data Available</staticValue>
																			</dataSource>
																			<style>
																				<CSS value="padding:10px 18px;"/>
																			</style>
																		</textItem>
																	</contents>
																</block>
															</contents>
														</noDataHandler>
														<XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Storage at Rest </staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(by Array)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart depth="9" maxHotspots="10000" name="Combination Chart2" refQuery="Performance by Array">
														<v2_combinationTypeTooltips/>
														<v2_commonAxis>
															<v2_ordinalAxis autoTruncation="false" manualTruncationMaxChars="12" truncationText="...">
																<v2_axisLabels>
																	<style>
																		<defaultStyles>
																			<defaultStyle refStyle="al"/>
																		</defaultStyles>
																	<CSS value="color:#454545"/></style>
																</v2_axisLabels>
															</v2_ordinalAxis>
														<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Storage Name"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="Total Allocated (TB)"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
														<v2_topLeftAxis>
															<v2_combinationChartTypes>
																<v2_bar barShape="box">
																	<v2_solidPalette>
																		<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
																	<!-- v2_solidPaletteRef ref=&amp;amp;amp;quot;gDefaultSolid&amp;amp;amp;quot;/ -->
																<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Total Allocated (TB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
															</v2_combinationChartTypes>
															<v2_axis>
																<v2_axisRange>
																	<v2_automaticRange/>
																</v2_axisRange>
																<v2_axisLabels>
																	<style>
																		<defaultStyles>
																			<defaultStyle refStyle="al"/>
																		</defaultStyles>
																	<CSS value="color:#454545"/><dataFormat><numberFormat pattern="###,###' TB'"/></dataFormat></style>
																</v2_axisLabels>
																<v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/>
															</v2_axis>
														</v2_topLeftAxis>
														<style>
															<defaultStyles>
																<defaultStyle refStyle="ch"/>
															</defaultStyles>
															<CSS value="width:500px;height:250px"/></style>
														<noDataHandler>
															<contents>
																<block>
																	<contents>
																		<textItem>
																			<dataSource>
																				<staticValue>No Data Available</staticValue>
																			</dataSource>
																			<style>
																				<CSS value="padding:10px 18px;"/>
																			</style>
																		</textItem>
																	</contents>
																</block>
															</contents>
														</noDataHandler>
														<XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Volumes at Rest Trend</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Count)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" name="Combination Chart7" refQuery="Volumes at Rest Trending">
																				<v2_combinationTypeTooltips/>
																				<v2_commonAxis>
																					<v2_ordinalAxis>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/></style>
																						</v2_axisLabels>
																					</v2_ordinalAxis>
																					<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Date"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Date"/></dataSource></chartTextItem></chartContents><style><dataFormat><dateFormat pattern="MM/dd"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																				<v2_topLeftAxis>
																					<v2_combinationChartTypes>
																						<v2_line lineAreaShape="smooth" lineDisplayType="lineAndMarkers"><v2_linePalette markerBorderColor="white" markerBorders="show" markerSize="8px"><v2_linePaletteEntries><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#8599D3"><v2_solidColor color="#9ABCC3" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#8599D3"><v2_color color="#9ABCC3"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#E3AE6C"><v2_solidColor color="#A8E3D7" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#E3AE6C"><v2_color color="#A8E3D7"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry><v2_lineFill defaultColor="#198545"><v2_color color="#88B2D3"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry><v2_lineFill defaultColor="#198545"><v2_color color="#FFB2C1"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry></v2_linePaletteEntries></v2_linePalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Vol Count"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_line></v2_combinationChartTypes>
																					<v2_axis>
																						<v2_axisRange scale="linear">
																							
																						<v2_automaticRange sameRangeAllInstances="true" includeZeroForAutoScale="true"/></v2_axisRange>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/><dataFormat><numberFormat pattern="###,### vols"/></dataFormat></style>
																						</v2_axisLabels>
																						<v2_majorGridlines lineColor="#E1E1E2" lineWeight="0"/>
																					</v2_axis>
																				</v2_topLeftAxis>
																				<style>
																					<defaultStyles>
																						<defaultStyle refStyle="ch"/>
																					</defaultStyles>
																					<CSS value="width:500px;height:250px"/></style>
																				<noDataHandler>
																					<contents>
																						<block>
																							<contents>
																								<textItem>
																									<dataSource>
																										<staticValue>No Data Available</staticValue>
																									</dataSource>
																									<style>
																										<CSS value="padding:10px 18px;"/>
																									</style>
																								</textItem>
																							</contents>
																						</block>
																					</contents>
																				</noDataHandler>
																				
																				<XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes><v2_notes><v2_note refQuery="Volumes at Rest Trending"><v2_chartTextItems><v2_chartTextItem><dataSource><staticValue>Current Volumes at Rest: </staticValue></dataSource></v2_chartTextItem><v2_chartTextItem><dataSource><dataItemValue refDataItem="Current Count"/></dataSource></v2_chartTextItem></v2_chartTextItems><style><CSS value="font-size:12pt;color:gray;font-weight:bold"/></style><v2_constrainedPosition><v2_verticalPosition><v2_bottom offset="75px"/></v2_verticalPosition><v2_horizontalPosition><v2_right offset="0px"/></v2_horizontalPosition><v2_positionAnchor><v2_relativeChart/></v2_positionAnchor></v2_constrainedPosition></v2_note></v2_notes></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top;padding-left:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="height:10px;background-color:#F7F7F7;padding-top:5px;padding-right:10px;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;width:100%;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Volumes at Rest</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Past 90 Days)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<list horizontalPagination="true" name="List1" refQuery="All Volumes" rowsPerPage="15000">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse;width:100%"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Storage Name"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Storage Name"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Volume"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;width:400px;word-wrap:break-word;word-break:break-all"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Volume"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Type"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Type"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Total Allocated (GB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><numberFormat decimalSize="2"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Total Allocated (GB)"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns><sortList><sortItem refDataItem="Total Allocated (GB)" sortOrder="descending"/></sortList></list></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;width:100%;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>VMs Powered Off</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Past 90 Days)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<list horizontalPagination="true" name="List2" refQuery="VMware Powered Off" rowsPerPage="15000">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse;width:100%"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="ESX Host"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="ESX Host"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="VM Guest"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="VM Guest"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Capacity (GB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><numberFormat decimalSize="2"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Capacity (GB)"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns><sortList><sortItem refDataItem="Capacity (GB)" sortOrder="descending"/></sortList></list></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top;padding-left:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;width:100%;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>VMs at Rest</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Past 90 Days)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<list horizontalPagination="true" name="List3" refQuery="All VM's at Rest" rowsPerPage="15000">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse;width:100%"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="ESX Host"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="ESX Host"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="VM Guest"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="VM Guest"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Capacity (GB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><numberFormat decimalSize="2"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Capacity (GB)"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns><sortList><sortItem refDataItem="Capacity (GB)" sortOrder="descending"/></sortList></list></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top;padding-left:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="background-color:#F7F7F7;padding-top:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="background-color:#F7F7F7;padding-right:10px;padding-left:10px;padding-bottom:10px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents>
								</pageBody>
								
								<pageFooter>
									<contents>
										
									<table>
                                            <tableRows>
                                                <tableRow>
                                                    <tableCells>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <image>
            <dataSource>
                <staticValue>../sanscreen/images/netapp_logo.png</staticValue>
            </dataSource>
        <style><CSS value="width:90px;height:36px"/></style></image></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:left;width:30%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                <textItem><dataSource><staticValue>Page </staticValue></dataSource></textItem><pageNumber/>
                                                            </contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:center;color:#9EA2A2;font-family:Helvetica;font-size:12px;width:40%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <textItem><dataSource><staticValue>OnCommand Insight 7.3.  2014-18 NetApp.</staticValue></dataSource><style><CSS value="font-weight:normal"/></style></textItem></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:right;width:30%;color:#9EA2A2;font-family:Arial;font-size:12px"/>
                                                            </style>
                                                        </tableCell>
                                                    </tableCells>
                                                </tableRow>
                                            </tableRows>
                                            <style>
                                                <defaultStyles>
                                                    <defaultStyle refStyle="tb"/>
                                                </defaultStyles>
                                                <CSS value="border-collapse:collapse;width:100%;height:32px"/>
                                            </style>
                                        </table></contents>
									<style>
										<defaultStyles>
											<defaultStyle refStyle="pf"/>
										</defaultStyles>
										<CSS value="padding-top:10px"/>
									</style>
								</pageFooter>
							</page>
						</reportPages>
					</layout>
				</layouts>
			<XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" output="no" value="true"/><XMLAttribute name="listSeparator" output="no" value=","/><XMLAttribute name="RS_modelModificationTime" output="no" value="2017-11-15T20:33:46.905Z"/></XMLAttributes><reportName>3.13 Storage at Rest</reportName><queries><query name="Performance by NetApp Volume">
			<source>
				
			<sqlQuery dataSource="dwh_performance" name="SQL1" type="passThrough">
			<sqlText>SELECT DISTINCT
dwh_performance.storage_dimension.name as 'Storage Name',
dwh_performance.storage_pool_dimension.name as 'Pool Name',
SUBSTR(dwh_performance.internal_volume_dimension.name, LOCATE(':', dwh_performance.internal_volume_dimension.name)+1, length(dwh_performance.internal_volume_dimension.name)) as 'Volume Name',
dwh_performance.internal_volume_daily_performance_fact.totalthroughput as 'TotalMBps',
dwh_inventory.internal_volume.totalAllocatedCapacityMB/1024 as 'Total Allocated (GB)'

FROM 	dwh_performance.internal_volume_daily_performance_fact
JOIN 	dwh_performance.storage_dimension
ON	dwh_performance.storage_dimension.tk=dwh_performance.internal_volume_daily_performance_fact.storagetk
JOIN	dwh_performance.storage_pool_dimension
ON	dwh_performance.storage_pool_dimension.tk=dwh_performance.internal_volume_daily_performance_fact.storagepooltk
JOIN	dwh_performance.internal_volume_dimension
ON	dwh_performance.internal_volume_dimension.tk=dwh_performance.internal_volume_daily_performance_fact.internalvolumetk
JOIN	dwh_inventory.internal_volume
ON	dwh_inventory.internal_volume.id=dwh_performance.internal_volume_dimension.id
JOIN	dwh_performance.date_dimension
On	dwh_performance.date_dimension.tk=dwh_performance.internal_volume_daily_performance_fact.datetk

WHERE dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate) 
FROM dwh_performance.date_dimension JOIN dwh_performance.internal_volume_daily_performance_fact 
ON dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 91 DAY
AND
dwh_performance.internal_volume_daily_performance_fact.totalthroughput=0

GROUP BY dwh_performance.storage_dimension.name, dwh_performance.storage_pool_dimension.name , dwh_inventory.internal_volume.id

ORDER BY dwh_inventory.internal_volume.totalAllocatedCapacityMB DESC LIMIT 10</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Pool Name"/><mdProjectedItem name="Volume Name"/><mdProjectedItem name="TotalMBps"/><mdProjectedItem name="Total Allocated (GB)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Storage Name"><expression>[SQL1].[Storage Name]</expression></dataItem><dataItem name="Pool Name"><expression>[SQL1].[Pool Name]</expression></dataItem><dataItem name="Volume Name"><expression>[SQL1].[Volume Name]</expression></dataItem><dataItem name="TotalMBps"><expression>[SQL1].[TotalMBps]</expression></dataItem><dataItem aggregate="total" name="Total Allocated (GB)"><expression>[SQL1].[Total Allocated (GB)]</expression></dataItem></selection>
		<queryHints><queryProcessing value="minimizeLocal"/></queryHints><detailFilters><detailFilter><filterExpression>[TotalMBps]=0</filterExpression></detailFilter></detailFilters></query><query name="Performance by SAN Volume">
			<source>
				
			<sqlQuery dataSource="dwh_performance" name="SQL1" type="passThrough">
			<sqlText>SELECT
dwh_performance.storage_dimension.name as 'Storage Name',
dwh_performance.storage_pool_dimension.name as 'Pool Name',
dwh_performance.volume_dimension.name as 'Volume Name',
dwh_performance.volume_daily_performance_fact.totalthroughput as 'TotalMBps',
dwh_inventory.volume.CapacityMB/1024 as 'Total Allocated (GB)'

FROM 	dwh_performance.volume_daily_performance_fact
JOIN 	dwh_performance.storage_dimension
ON	dwh_performance.storage_dimension.tk=dwh_performance.volume_daily_performance_fact.storagetk
JOIN	dwh_performance.storage_pool_dimension
ON	dwh_performance.storage_pool_dimension.tk=dwh_performance.volume_daily_performance_fact.storagepooltk
JOIN	dwh_performance.volume_dimension
ON	dwh_performance.volume_dimension.tk=dwh_performance.volume_daily_performance_fact.volumetk
JOIN	dwh_inventory.volume
ON	dwh_inventory.volume.id=dwh_performance.volume_dimension.id
JOIN	dwh_performance.date_dimension
On	dwh_performance.date_dimension.tk=dwh_performance.volume_daily_performance_fact.datetk

WHERE dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate) 
FROM dwh_performance.date_dimension JOIN dwh_performance.volume_daily_performance_fact 
ON dwh_performance.volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 91 DAY
AND
dwh_performance.volume_daily_performance_fact.totalthroughput=0

GROUP BY dwh_performance.volume_dimension.tk

ORDER BY dwh_inventory.volume.CapacityMB DESC LIMIT 10</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Pool Name"/><mdProjectedItem name="Volume Name"/><mdProjectedItem name="TotalMBps"/><mdProjectedItem name="Total Allocated (GB)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Storage Name"><expression>[SQL1].[Storage Name]</expression></dataItem><dataItem name="Pool Name"><expression>[SQL1].[Pool Name]</expression></dataItem><dataItem name="Volume Name"><expression>[SQL1].[Volume Name]</expression></dataItem><dataItem name="TotalMBps"><expression>[SQL1].[TotalMBps]</expression></dataItem><dataItem aggregate="total" name="Total Allocated (GB)"><expression>[SQL1].[Total Allocated (GB)]</expression></dataItem></selection>
		<queryHints><queryProcessing value="minimizeLocal"/></queryHints><detailFilters><detailFilter><filterExpression>[TotalMBps]=0</filterExpression></detailFilter></detailFilters></query><query name="Performance by Array">
			<source>
				
			<sqlQuery dataSource="dwh_performance" name="SQL1" type="passThrough">
			<sqlText>SELECT
dwh_performance.storage_dimension.name as 'Storage Name',
dwh_performance.internal_volume_daily_performance_fact.totalthroughput as 'TotalMBps',
dwh_inventory.internal_volume.totalAllocatedCapacityMB/1024/1024 as 'Total Allocated (TB)',
0 as 'Usable Capacity (TB)'


FROM 	dwh_performance.internal_volume_daily_performance_fact
JOIN 	dwh_performance.storage_dimension
ON	dwh_performance.storage_dimension.tk=dwh_performance.internal_volume_daily_performance_fact.storagetk
JOIN	dwh_performance.internal_volume_dimension
ON	dwh_performance.internal_volume_dimension.tk=dwh_performance.internal_volume_daily_performance_fact.internalvolumetk
JOIN	dwh_inventory.internal_volume
ON	dwh_inventory.internal_volume.id=dwh_performance.internal_volume_dimension.id
JOIN	dwh_performance.date_dimension
On	dwh_performance.date_dimension.tk=dwh_performance.internal_volume_daily_performance_fact.datetk

WHERE dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate) 
FROM dwh_performance.date_dimension JOIN dwh_performance.internal_volume_daily_performance_fact 
ON dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 91 DAY
AND
dwh_performance.internal_volume_daily_performance_fact.totalthroughput=0

GROUP BY dwh_performance.storage_dimension.name,  dwh_performance.internal_volume_dimension.name

UNION

SELECT
dwh_performance.storage_dimension.name as 'Storage Name',
dwh_performance.volume_daily_performance_fact.totalthroughput as 'TotalMBps',
dwh_inventory.volume.CapacityMB/1024/1024 as 'Total Allocated (TB)',
0 as 'Usable Capacity (TB)'


FROM 	dwh_performance.volume_daily_performance_fact
JOIN 	dwh_performance.storage_dimension
ON	dwh_performance.storage_dimension.tk=dwh_performance.volume_daily_performance_fact.storagetk
JOIN	dwh_performance.volume_dimension
ON	dwh_performance.volume_dimension.tk=dwh_performance.volume_daily_performance_fact.volumetk
JOIN	dwh_inventory.volume
ON	dwh_inventory.volume.id=dwh_performance.volume_dimension.id
JOIN	dwh_performance.date_dimension
On	dwh_performance.date_dimension.tk=dwh_performance.volume_daily_performance_fact.datetk

WHERE dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate) 
FROM dwh_performance.date_dimension JOIN dwh_performance.volume_daily_performance_fact 
ON dwh_performance.volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 91 DAY
AND
dwh_performance.volume_daily_performance_fact.totalthroughput=0

GROUP BY dwh_performance.storage_dimension.name,  dwh_performance.volume_dimension.name 

UNION

SELECT
dwh_inventory.storage.name as 'Storage Name',
0 as 'TotalMBps',
0 as 'Total Allocated (TB)',
dwh_inventory.storage_pool.totalAllocatedCapacityMB/1024/1024 as 'Usable Capacity (TB)'
FROM dwh_inventory.storage JOIN  dwh_inventory.storage_pool ON dwh_inventory.storage_pool.storageid=dwh_inventory.storage.id

GROUP BY dwh_inventory.storage.id, dwh_inventory.storage_pool.id








</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Name"/><mdProjectedItem name="TotalMBps"/><mdProjectedItem name="Total Allocated (TB)"/><mdProjectedItem name="Usable Capacity (TB)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Storage Name"><expression>[SQL1].[Storage Name]</expression></dataItem><dataItem name="TotalMBps"><expression>[SQL1].[TotalMBps]</expression></dataItem><dataItem aggregate="total" name="Total Allocated (TB)"><expression>[SQL1].[Total Allocated (TB)]</expression></dataItem><dataItem name="Usable Capacity (TB)" aggregate="total"><expression>[SQL1].[Usable Capacity (TB)]</expression></dataItem><dataItem name="% of Usable"><expression>[Total Allocated (TB)]/[Usable Capacity (TB)]</expression></dataItem></selection>
		<queryHints><queryProcessing value="minimizeLocal"/></queryHints></query><query name="VMware Powered Off">
			<source>
				
			<sqlQuery dataSource="dwh_inventory" name="SQL2" type="passThrough">
			<sqlText>SELECT
dwh_inventory.host.name as 'ESX Host',
dwh_inventory.hv_virtual_machine.name as 'VM Guest',
dwh_inventory.hv_virtual_machine.powerStateChangeTime,
dwh_inventory.hv_virtual_machine.provisionedCapacityMB/1024 as 'Capacity (GB)'

FROM dwh_inventory.hv_virtual_machine
JOIN  dwh_inventory.host
ON   dwh_inventory.host.id=dwh_inventory.hv_virtual_machine.hostid

WHERE 
dwh_inventory.hv_virtual_machine.powerState='poweredOff' AND
dwh_inventory.hv_virtual_machine.powerStateChangeTime &lt;= NOW() - INTERVAL 30 DAY

ORDER BY dwh_inventory.hv_virtual_machine.provisionedCapacityMB DESC LIMIT 20


</sqlText>
		<mdProjectedItems><mdProjectedItem name="ESX Host"/><mdProjectedItem name="VM Guest"/><mdProjectedItem name="powerStateChangeTime"/><mdProjectedItem name="Capacity (GB)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="ESX Host"><expression>[SQL2].[ESX Host]</expression></dataItem><dataItem name="VM Guest"><expression>[SQL2].[VM Guest]</expression></dataItem><dataItem name="powerStateChangeTime"><expression>[SQL2].[powerStateChangeTime]</expression></dataItem><dataItem aggregate="total" name="Capacity (TB)"><expression>[SQL2].[Capacity (GB)]/1024</expression></dataItem><dataItem name="Capacity (GB)" aggregate="total"><expression>[SQL2].[Capacity (GB)]</expression></dataItem></selection>
		</query><query name="VMware at Rest">
			<source>
				
			<sqlQuery dataSource="dwh_performance" name="SQL3" type="passThrough">
			<sqlText>SELECT
dwh_performance.vm_dimension.name as 'VM Guest',
dwh_performance.vm_daily_performance_fact.totalthroughput as 'TotalMBps',
dwh_inventory.hv_virtual_machine.provisionedCapacityMB/1024 as 'Capacity (GB)'

FROM 	dwh_performance.vm_daily_performance_fact
JOIN	dwh_performance.vm_dimension
ON	dwh_performance.vm_dimension.tk=dwh_performance.vm_daily_performance_fact.vmtk
JOIN	dwh_inventory.hv_virtual_machine
ON	dwh_inventory.hv_virtual_machine.id=dwh_performance.vm_dimension.id
JOIN	dwh_performance.date_dimension
ON	dwh_performance.date_dimension.tk=dwh_performance.vm_daily_performance_fact.datetk

WHERE dwh_performance.date_dimension.fulldate &lt;= NOW() - INTERVAL 91 DAY 
AND
dwh_performance.vm_daily_performance_fact.totalthroughput=0

GROUP BY dwh_performance.vm_dimension.name 

ORDER BY dwh_inventory.hv_virtual_machine.provisionedCapacityMB DESC LIMIT 10</sqlText>
		<mdProjectedItems><mdProjectedItem name="VM Guest"/><mdProjectedItem name="TotalMBps"/><mdProjectedItem name="Capacity (GB)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="VM Guest"><expression>[SQL3].[VM Guest]</expression></dataItem><dataItem name="TotalMBps"><expression>[SQL3].[TotalMBps]</expression></dataItem><dataItem aggregate="total" name="Capacity (TB)"><expression>[SQL3].[Capacity (GB)]/1024</expression></dataItem><dataItem name="Capacity (GB)" aggregate="total"><expression>[SQL3].[Capacity (GB)]</expression></dataItem></selection>
		</query><query name="All Volumes">
			<source>
				
			<sqlQuery dataSource="dwh_performance" name="SQL1" type="passThrough">
			<sqlText>SELECT
dwh_performance.storage_dimension.name as 'Storage Name',
dwh_performance.internal_volume_dimension.name as 'Volume',
'NAS' as 'Type',
dwh_performance.internal_volume_daily_performance_fact.totalthroughput as 'TotalMBps',
dwh_inventory.internal_volume.totalAllocatedCapacityMB/1024/1024 as 'Total Allocated (TB)'


FROM 	dwh_performance.internal_volume_daily_performance_fact
JOIN 	dwh_performance.storage_dimension
ON	dwh_performance.storage_dimension.tk=dwh_performance.internal_volume_daily_performance_fact.storagetk
JOIN	dwh_performance.internal_volume_dimension
ON	dwh_performance.internal_volume_dimension.tk=dwh_performance.internal_volume_daily_performance_fact.internalvolumetk
JOIN	dwh_inventory.internal_volume
ON	dwh_inventory.internal_volume.id=dwh_performance.internal_volume_dimension.id
JOIN	dwh_performance.date_dimension
On	dwh_performance.date_dimension.tk=dwh_performance.internal_volume_daily_performance_fact.datetk

WHERE dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate) 
FROM dwh_performance.date_dimension JOIN dwh_performance.internal_volume_daily_performance_fact 
ON dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 91 DAY
AND
dwh_performance.internal_volume_daily_performance_fact.totalthroughput=0

GROUP BY dwh_performance.storage_dimension.name,  dwh_performance.internal_volume_dimension.name

UNION

SELECT
dwh_performance.storage_dimension.name as 'Storage Name',
dwh_performance.volume_dimension.name as 'Volume',
'SAN' as 'Type',
dwh_performance.volume_daily_performance_fact.totalthroughput as 'TotalMBps',
dwh_inventory.volume.CapacityMB/1024/1024 as 'Total Allocated (TB)'


FROM 	dwh_performance.volume_daily_performance_fact
JOIN 	dwh_performance.storage_dimension
ON	dwh_performance.storage_dimension.tk=dwh_performance.volume_daily_performance_fact.storagetk
JOIN	dwh_performance.volume_dimension
ON	dwh_performance.volume_dimension.tk=dwh_performance.volume_daily_performance_fact.volumetk
JOIN	dwh_inventory.volume
ON	dwh_inventory.volume.id=dwh_performance.volume_dimension.id
JOIN	dwh_performance.date_dimension
On	dwh_performance.date_dimension.tk=dwh_performance.volume_daily_performance_fact.datetk

WHERE dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate) 
FROM dwh_performance.date_dimension JOIN dwh_performance.volume_daily_performance_fact 
ON dwh_performance.volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 91 DAY
AND
dwh_performance.volume_daily_performance_fact.totalthroughput=0

GROUP BY dwh_performance.storage_dimension.name,  dwh_performance.volume_dimension.name




</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Volume"/><mdProjectedItem name="Type"/><mdProjectedItem name="TotalMBps"/><mdProjectedItem name="Total Allocated (TB)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Storage Name"><expression>[SQL1].[Storage Name]</expression></dataItem><dataItem name="Volume"><expression>[SQL1].[Volume]</expression></dataItem><dataItem name="TotalMBps"><expression>[SQL1].[TotalMBps]</expression></dataItem><dataItem aggregate="total" name="Total Allocated (TB)"><expression>[SQL1].[Total Allocated (TB)]</expression></dataItem><dataItem name="Type"><expression>[SQL1].[Type]</expression></dataItem><dataItem name="Total Allocated (GB)"><expression>[SQL1].[Total Allocated (TB)]*1024
</expression></dataItem></selection>
		<queryHints><queryProcessing value="minimizeLocal"/></queryHints><detailFilters><detailFilter><filterExpression>[TotalMBps]=0</filterExpression></detailFilter></detailFilters></query><query name="All VM's at Rest">
			<source>
				
			<sqlQuery dataSource="dwh_performance" name="SQL3" type="passThrough">
			<sqlText>SELECT
dwh_inventory.host.name as 'ESX Host',
dwh_performance.vm_dimension.name as 'VM Guest',
dwh_performance.vm_daily_performance_fact.totalthroughput as 'TotalMBps',
dwh_inventory.hv_virtual_machine.provisionedCapacityMB/1024 as 'Capacity (GB)'

FROM 	dwh_performance.vm_daily_performance_fact
JOIN	dwh_performance.vm_dimension
ON	dwh_performance.vm_dimension.tk=dwh_performance.vm_daily_performance_fact.vmtk
JOIN	dwh_inventory.hv_virtual_machine
ON	dwh_inventory.hv_virtual_machine.id=dwh_performance.vm_dimension.id
JOIN	dwh_inventory.host
ON	dwh_inventory.host.id=dwh_inventory.hv_virtual_machine.hostid
JOIN	dwh_performance.date_dimension
ON	dwh_performance.date_dimension.tk=dwh_performance.vm_daily_performance_fact.datetk

WHERE dwh_performance.date_dimension.fulldate &lt;= NOW() - INTERVAL 91 DAY 
AND
dwh_performance.vm_daily_performance_fact.totalthroughput=0

GROUP BY dwh_inventory.host.id, dwh_performance.vm_dimension.name 

</sqlText>
		<mdProjectedItems><mdProjectedItem name="ESX Host"/><mdProjectedItem name="VM Guest"/><mdProjectedItem name="TotalMBps"/><mdProjectedItem name="Capacity (GB)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="ESX Host"><expression>[SQL3].[ESX Host]</expression></dataItem><dataItem name="VM Guest"><expression>[SQL3].[VM Guest]</expression></dataItem><dataItem name="TotalMBps"><expression>[SQL3].[TotalMBps]</expression></dataItem><dataItem aggregate="total" name="Capacity (GB)"><expression>[SQL3].[Capacity (GB)]</expression></dataItem></selection>
		</query><query name="Orphaned VMDK">
			<source>
				
			<sqlQuery dataSource="dwh_inventory" name="SQL4" type="passThrough">
			<sqlText>SELECT

dwh_performance.vmdk_dimension.name as 'VMDK',
dwh_inventory.hv_virtual_disk.capacityMB/1024 as 'Capacity GB',
dwh_performance.vm_dimension.name as 'VM Guest',
dwh_inventory.hv_virtual_machine.powerstate as 'Guest State',
dwh_inventory.hv_virtual_machine.powerstatechangetime as 'Guest Change Time'

FROM 	dwh_performance.vmdk_daily_performance_fact
JOIN	dwh_performance.vmdk_dimension
ON	dwh_performance.vmdk_dimension.tk=dwh_performance.vmdk_daily_performance_fact.vmdktk
LEFT JOIN	dwh_inventory.hv_virtual_disk
ON	dwh_inventory.hv_virtual_disk.id=dwh_performance.vmdk_dimension.id
LEFT JOIN	dwh_performance.vm_dimension
ON	dwh_performance.vm_dimension.tk=dwh_performance.vmdk_daily_performance_fact.vmtk
JOIN	dwh_inventory.hv_virtual_machine
ON	dwh_inventory.hv_virtual_machine.id=dwh_performance.vm_dimension.id
AND	dwh_inventory.hv_virtual_machine.powerstate='PoweredOff'
JOIN	dwh_performance.date_dimension
ON	dwh_performance.date_dimension.tk=dwh_performance.vmdk_daily_performance_fact.datetk

WHERE 
dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate) 
FROM dwh_performance.date_dimension JOIN dwh_performance.vmdk_daily_performance_fact ON dwh_performance.vmdk_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 91 DAY
AND dwh_performance.vmdk_daily_performance_fact.totalthroughput=0



GROUP BY dwh_performance.vmdk_dimension.name

</sqlText>
		<mdProjectedItems><mdProjectedItem name="VMDK"/><mdProjectedItem name="Capacity GB"/><mdProjectedItem name="VM Guest"/><mdProjectedItem name="Guest State"/><mdProjectedItem name="Guest Change Time"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="VMDK"><expression>[SQL4].[VMDK]</expression></dataItem><dataItem name="Capacity GB"><expression>[SQL4].[Capacity GB]</expression></dataItem><dataItem name="VM Guest"><expression>[SQL4].[VM Guest]</expression></dataItem><dataItem name="Guest State"><expression>[SQL4].[Guest State]</expression></dataItem><dataItem name="Guest Change Time"><expression>[SQL4].[Guest Change Time]</expression></dataItem></selection>
		</query><query name="Query1">
			<source>
				
			<sqlQuery dataSource="dwh_performance" name="SQL5" type="passThrough">
			<sqlText>SELECT DISTINCT
'NAS' as 'Tier',
dwh_performance.storage_dimension.name as 'HA-Pair/Cluser',
SUBSTR(dwh_performance.storage_pool_dimension.name,1,LOCATE(':', dwh_performance.storage_pool_dimension.name)-1) as 'Controller/Node',
dwh_performance.storage_pool_dimension.name as 'Aggregate',
SUBSTR(dwh_performance.internal_volume_dimension.name, LOCATE(':', dwh_performance.internal_volume_dimension.name)+1, length(dwh_performance.internal_volume_dimension.name)) as 'Volume Name',
dwh_performance.internal_volume_daily_performance_fact.totalthroughput as 'TotalMBps',
ROUND(dwh_inventory.internal_volume.totalAllocatedCapacityMB/1024,2) as 'Total Allocated (GB)'

FROM 	dwh_performance.internal_volume_daily_performance_fact
JOIN 	dwh_performance.storage_dimension
ON	dwh_performance.storage_dimension.tk=dwh_performance.internal_volume_daily_performance_fact.storagetk
AND     dwh_performance.storage_dimension.manufacturer = 'NetApp'

JOIN	dwh_performance.storage_pool_dimension
ON	dwh_performance.storage_pool_dimension.tk=dwh_performance.internal_volume_daily_performance_fact.storagepooltk
AND     dwh_performance.storage_pool_dimension.name NOT LIKE '%root%'
AND     dwh_performance.storage_pool_dimension.name NOT LIKE '%aggr0'
AND     dwh_performance.storage_pool_dimension.name NOT LIKE '%aggr0\_%'

JOIN	dwh_performance.internal_volume_dimension
ON	dwh_performance.internal_volume_dimension.tk=dwh_performance.internal_volume_daily_performance_fact.internalvolumetk
AND     dwh_performance.internal_volume_dimension.latest = 1
AND     dwh_performance.internal_volume_dimension.name NOT LIKE '%vol0'
AND     dwh_performance.internal_volume_dimension.name NOT LIKE '%root%'

JOIN	dwh_inventory.internal_volume
ON	dwh_inventory.internal_volume.id=dwh_performance.internal_volume_dimension.id
AND     dwh_inventory.internal_volume.id NOT IN (SELECT dwh_inventory.dr_internal_volume_replica.targetInternalVolumeId FROM dwh_inventory.dr_internal_volume_replica)

JOIN	dwh_performance.date_dimension
On	dwh_performance.date_dimension.tk=dwh_performance.internal_volume_daily_performance_fact.datetk


WHERE dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate) 
FROM dwh_performance.date_dimension JOIN dwh_performance.internal_volume_daily_performance_fact 
ON dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 181 DAY
AND
dwh_performance.internal_volume_daily_performance_fact.totalthroughput=0

GROUP BY dwh_performance.storage_dimension.name, dwh_performance.storage_pool_dimension.name , dwh_inventory.internal_volume.id

</sqlText>
		<mdProjectedItems><mdProjectedItem name="Tier"/><mdProjectedItem name="HA-Pair/Cluser"/><mdProjectedItem name="Controller/Node"/><mdProjectedItem name="Aggregate"/><mdProjectedItem name="Volume Name"/><mdProjectedItem name="TotalMBps"/><mdProjectedItem name="Total Allocated (GB)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Tier"><expression>[SQL5].[Tier]</expression></dataItem><dataItem name="HA-Pair/Cluser"><expression>[SQL5].[HA-Pair/Cluser]</expression></dataItem><dataItem name="Controller/Node"><expression>[SQL5].[Controller/Node]</expression></dataItem><dataItem name="Aggregate"><expression>[SQL5].[Aggregate]</expression></dataItem><dataItem name="Volume Name"><expression>[SQL5].[Volume Name]</expression></dataItem><dataItem name="TotalMBps"><expression>[SQL5].[TotalMBps]</expression></dataItem><dataItem name="Total Allocated (GB)"><expression>[SQL5].[Total Allocated (GB)]</expression></dataItem></selection>
		</query><query name="Volumes at Rest Trending">
			<source>
				
			<sqlQuery name="SQL6" dataSource="dwh_performance" type="passThrough">
			<sqlText>SELECT

dwh_performance.internal_volume_dimension.name as 'Volume',
dwh_performance.date_dimension.fulldate as 'Date'

FROM 	dwh_performance.internal_volume_daily_performance_fact
JOIN 	dwh_performance.storage_dimension
ON	dwh_performance.storage_dimension.tk=dwh_performance.internal_volume_daily_performance_fact.storagetk
JOIN	dwh_performance.internal_volume_dimension
ON	dwh_performance.internal_volume_dimension.tk=dwh_performance.internal_volume_daily_performance_fact.internalvolumetk
JOIN	dwh_inventory.internal_volume
ON	dwh_inventory.internal_volume.id=dwh_performance.internal_volume_dimension.id
JOIN	dwh_performance.date_dimension
On	dwh_performance.date_dimension.tk=dwh_performance.internal_volume_daily_performance_fact.datetk

WHERE dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate) 
FROM dwh_performance.date_dimension JOIN dwh_performance.internal_volume_daily_performance_fact 
ON dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 91 DAY
AND
dwh_performance.internal_volume_daily_performance_fact.totalthroughput=0

GROUP BY dwh_performance.storage_dimension.name,  dwh_performance.internal_volume_dimension.name, dwh_performance.date_dimension.fulldate

UNION

SELECT
dwh_performance.volume_dimension.name as 'Volume',
dwh_performance.date_dimension.fulldate as 'Date'



FROM 	dwh_performance.volume_daily_performance_fact
JOIN 	dwh_performance.storage_dimension
ON	dwh_performance.storage_dimension.tk=dwh_performance.volume_daily_performance_fact.storagetk
JOIN	dwh_performance.volume_dimension
ON	dwh_performance.volume_dimension.tk=dwh_performance.volume_daily_performance_fact.volumetk
JOIN	dwh_inventory.volume
ON	dwh_inventory.volume.id=dwh_performance.volume_dimension.id
JOIN	dwh_performance.date_dimension
On	dwh_performance.date_dimension.tk=dwh_performance.volume_daily_performance_fact.datetk

WHERE dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate) 
FROM dwh_performance.date_dimension JOIN dwh_performance.volume_daily_performance_fact 
ON dwh_performance.volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 91 DAY
AND
dwh_performance.volume_daily_performance_fact.totalthroughput=0

GROUP BY dwh_performance.storage_dimension.name,  dwh_performance.volume_dimension.name, dwh_performance.date_dimension.fulldate




</sqlText>
		<mdProjectedItems><mdProjectedItem name="Volume"/><mdProjectedItem name="Date"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Date"><expression>[SQL6].[Date]</expression></dataItem><dataItem name="Volume"><expression>[SQL6].[Volume]</expression></dataItem><dataItem name="Vol Count" rollupAggregate="total"><expression>count(distinct [Volume] for [Date])</expression></dataItem><dataItem name="Max Date"><expression>maximum([Date] for report)</expression></dataItem><dataItem name="Current Count" aggregate="maximum"><expression>IF([Date]=[Max Date]) THEN ([Vol Count]) ELSE (0)</expression></dataItem></selection>
		</query></queries></report>